﻿CREATE TABLE [dbo].[Medicament] (
    [Id_Medicament]      INT            IDENTITY (1, 1) NOT NULL,
    [Id_SubstantaActiva] INT            NOT NULL,
    [NumeMedicament]     NVARCHAR (MAX) NOT NULL,
    [Id_Producator]      INT            NOT NULL,
    [CostVanzare]        FLOAT          NOT NULL,
    [CostCumparare]		 FLOAT			NOT NULL,
    [Deleted]            BIT            NOT NULL,
    [Compensat]          BIT            NOT NULL,
    [Id_UnitateMasura]   INT            NOT NULL
);

